/*
 Navicat Premium Data Transfer

 Source Server         : 121.4.18.224
 Source Server Type    : SQL Server
 Source Server Version : 16001000
 Source Host           : 121.4.18.224:1433
 Source Catalog        : devtools30
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001000
 File Encoding         : 65001

 Date: 18/12/2023 14:07:28
*/


-- ----------------------------
-- Table structure for devt_api_log
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_api_log]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_api_log]
GO

CREATE TABLE [dbo].[devt_api_log] (
  [cdate] datetime2(7)  NULL,
  [estatus] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jsondata] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [strsql] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [subid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [id] int  IDENTITY(1,1) NOT NULL,
  [errorinfo] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [subdm] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [subname] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_api_log] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_api_main
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_api_main]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_api_main]
GO

CREATE TABLE [dbo].[devt_api_main] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [cancel] bit  NULL,
  [dm] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [flid] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [mc] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [pym] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [url] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_api_main] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_api_sub
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_api_sub]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_api_sub]
GO

CREATE TABLE [dbo].[devt_api_sub] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [cacheflag] int  NULL,
  [cancel] bit  NULL,
  [created] datetime2(7)  NULL,
  [datalx] int  NULL,
  [dm] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [edittime] datetime2(7)  NULL,
  [formid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [isprocedure] int  NULL,
  [lx] int  NULL,
  [lxlabel] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [mainid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [maxcachetime] int  NULL,
  [mc] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [sql_] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [sqltype] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_api_sub] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_api_tjopt
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_api_tjopt]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_api_tjopt]
GO

CREATE TABLE [dbo].[devt_api_tjopt] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [argname] varchar(512) COLLATE Chinese_PRC_CI_AS  NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [cslx] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [isrequeried] int  NULL,
  [lx] int  NULL,
  [subid] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [tjsql] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_api_tjopt] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_api_tjoptcheck
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_api_tjoptcheck]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_api_tjoptcheck]
GO

CREATE TABLE [dbo].[devt_api_tjoptcheck] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [active] int  NULL,
  [bz] varchar(1024) COLLATE Chinese_PRC_CI_AS  NULL,
  [checktype] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [code] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [content] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [errorinfo] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [fieldcode] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [sub_id] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_api_tjoptcheck] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_api_type
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_api_type]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_api_type]
GO

CREATE TABLE [dbo].[devt_api_type] (
  [id] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [cancel] bit  NULL,
  [dm] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [mc] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_api_type] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_excel
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_excel]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_excel]
GO

CREATE TABLE [dbo].[devt_excel] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [name] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [bz] varchar(1024) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL,
  [type_id] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [table_id] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [file_length] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [datacontent] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [content_type] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [file_name_org] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [data_num] int  NULL,
  [head_num] int  NULL
)
GO

ALTER TABLE [dbo].[devt_excel] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'file_length',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel',
'COLUMN', N'file_length'
GO

EXEC sp_addextendedproperty
'MS_Description', N'datacontent',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel',
'COLUMN', N'datacontent'
GO

EXEC sp_addextendedproperty
'MS_Description', N'content_type',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel',
'COLUMN', N'content_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'file_name_org',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel',
'COLUMN', N'file_name_org'
GO

EXEC sp_addextendedproperty
'MS_Description', N'表头行数',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel',
'COLUMN', N'data_num'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据起始行数',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel',
'COLUMN', N'head_num'
GO


-- ----------------------------
-- Table structure for devt_excel_field
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_excel_field]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_excel_field]
GO

CREATE TABLE [dbo].[devt_excel_field] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [name] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL,
  [excel_id] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [field_id] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_excel_field] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_excel_log
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_excel_log]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_excel_log]
GO

CREATE TABLE [dbo].[devt_excel_log] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [username] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [excel_id] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [import_time] datetime  NULL,
  [file_length] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [datacontent] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [content_type] varchar(512) COLLATE Chinese_PRC_CI_AS  NULL,
  [file_name_org] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [status] int  NULL,
  [costdatatime] datetime  NULL
)
GO

ALTER TABLE [dbo].[devt_excel_log] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'上传用户账号',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel_log',
'COLUMN', N'username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'excelID',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel_log',
'COLUMN', N'excel_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'导入时间',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel_log',
'COLUMN', N'import_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'file_length',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel_log',
'COLUMN', N'file_length'
GO

EXEC sp_addextendedproperty
'MS_Description', N'datacontent',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel_log',
'COLUMN', N'datacontent'
GO

EXEC sp_addextendedproperty
'MS_Description', N'content_type',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel_log',
'COLUMN', N'content_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'file_name_org',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel_log',
'COLUMN', N'file_name_org'
GO

EXEC sp_addextendedproperty
'MS_Description', N'0.未发送.1.已发送.2.已废弃',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel_log',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据时间',
'SCHEMA', N'dbo',
'TABLE', N'devt_excel_log',
'COLUMN', N'costdatatime'
GO


-- ----------------------------
-- Table structure for devt_excel_type
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_excel_type]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_excel_type]
GO

CREATE TABLE [dbo].[devt_excel_type] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [name] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [sm] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_excel_type] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_form_design
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_form_design]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_form_design]
GO

CREATE TABLE [dbo].[devt_form_design] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [height] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [json_opt] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] varchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [templateid] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [width] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_form_design] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_form_fieldcheck
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_form_fieldcheck]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_form_fieldcheck]
GO

CREATE TABLE [dbo].[devt_form_fieldcheck] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [active] int  NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [checktype] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [code] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [content] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [errorinfo] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [fieldcode] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [templeid] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_form_fieldcheck] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_form_fieldconfig
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_form_fieldconfig]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_form_fieldconfig]
GO

CREATE TABLE [dbo].[devt_form_fieldconfig] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [datasql] varchar(max) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fieldid] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [tablecode] varchar(128) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [templateid] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[devt_form_fieldconfig] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_form_listtempl_args
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_form_listtempl_args]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_form_listtempl_args]
GO

CREATE TABLE [dbo].[devt_form_listtempl_args] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [arglable] varchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [argname] varchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [cslx] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [dvalue] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [formid] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [isshow] bigint  NULL,
  [jlsrccode] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [lx] int  NULL,
  [lxdata] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [templeid] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [tjsql] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_form_listtempl_args] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_form_listtempl_config
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_form_listtempl_config]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_form_listtempl_config]
GO

CREATE TABLE [dbo].[devt_form_listtempl_config] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [formid] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [height] varchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [ishow] int  NULL,
  [label] varchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [temlplecontent] varchar(3096) COLLATE Chinese_PRC_CI_AS  NULL,
  [temlpletype] int  NULL,
  [templeid] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_form_listtempl_config] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_form_listtempl_otherbtn
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_form_listtempl_otherbtn]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_form_listtempl_otherbtn]
GO

CREATE TABLE [dbo].[devt_form_listtempl_otherbtn] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [action] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [btnlabel] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [btnurl] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [formid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [height] int  NULL,
  [position] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [templeid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [useflag] int  NULL,
  [width] int  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_form_listtempl_otherbtn] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_form_listtempl_theader
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_form_listtempl_theader]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_form_listtempl_theader]
GO

CREATE TABLE [dbo].[devt_form_listtempl_theader] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [formid] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [headname] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [height] int  NULL,
  [templeid] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [width] int  NULL,
  [xh] int  NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_form_listtempl_theader] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_form_listtemplate
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_form_listtemplate]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_form_listtemplate]
GO

CREATE TABLE [dbo].[devt_form_listtemplate] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [active] int  NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [flid] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [form_id] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [importconf] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [pageflag] int  NULL,
  [sqltype] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [standard] int  NULL,
  [status] int  NULL,
  [stytle] bigint  NULL,
  [temlplelables] varchar(1024) COLLATE Chinese_PRC_CI_AS  NULL,
  [temlplesql] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [thcolconf] varchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [thconf] varchar(128) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_form_listtemplate] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_form_metadata
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_form_metadata]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_form_metadata]
GO

CREATE TABLE [dbo].[devt_form_metadata] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [tableid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [tabletype] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [templeid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_form_metadata] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_form_type
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_form_type]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_form_type]
GO

CREATE TABLE [dbo].[devt_form_type] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [cancel] bit  NULL,
  [f_type_id] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [sm] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [url_type] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_form_type] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_function_list
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_function_list]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_function_list]
GO

CREATE TABLE [dbo].[devt_function_list] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [code] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [type] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [url] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [createtime] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [delflag] int  NULL
)
GO

ALTER TABLE [dbo].[devt_function_list] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'功能编码',
'SCHEMA', N'dbo',
'TABLE', N'devt_function_list',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'功能名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_function_list',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'功能类型',
'SCHEMA', N'dbo',
'TABLE', N'devt_function_list',
'COLUMN', N'type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'访问路径',
'SCHEMA', N'dbo',
'TABLE', N'devt_function_list',
'COLUMN', N'url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'序号',
'SCHEMA', N'dbo',
'TABLE', N'devt_function_list',
'COLUMN', N'xh'
GO

EXEC sp_addextendedproperty
'MS_Description', N'功能备注',
'SCHEMA', N'dbo',
'TABLE', N'devt_function_list',
'COLUMN', N'bz'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'devt_function_list',
'COLUMN', N'createtime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'0未废除 1已废除',
'SCHEMA', N'dbo',
'TABLE', N'devt_function_list',
'COLUMN', N'delflag'
GO


-- ----------------------------
-- Table structure for devt_model_metadata_field
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_model_metadata_field]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_model_metadata_field]
GO

CREATE TABLE [dbo].[devt_model_metadata_field] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [field_code] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [field_name] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [field_type] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [form_id] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [patienttable] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [patienttablefield] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [pkey] int  NULL,
  [tabletype] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [type_length] int  NULL,
  [type_zero_length] int  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_model_metadata_field] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_model_metadata_table
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_model_metadata_table]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_model_metadata_table]
GO

CREATE TABLE [dbo].[devt_model_metadata_table] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [bz] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [code] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [type_id] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL,
  [modeltype] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [storetype] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [viewcode] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_model_metadata_table] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'模型类型',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_metadata_table',
'COLUMN', N'modeltype'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存储方式json common',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_metadata_table',
'COLUMN', N'storetype'
GO

EXEC sp_addextendedproperty
'MS_Description', N'视图代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_metadata_table',
'COLUMN', N'viewcode'
GO


-- ----------------------------
-- Table structure for devt_model_metadata_type
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_model_metadata_type]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_model_metadata_type]
GO

CREATE TABLE [dbo].[devt_model_metadata_type] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [flmc] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_model_metadata_type] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_model_organization
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_model_organization]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_model_organization]
GO

CREATE TABLE [dbo].[devt_model_organization] (
  [id] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [code] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [formversion] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [releasetime] datetime  NULL
)
GO

ALTER TABLE [dbo].[devt_model_organization] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'机构代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_organization',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'机构名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_organization',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'表单版本',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_organization',
'COLUMN', N'formversion'
GO

EXEC sp_addextendedproperty
'MS_Description', N'发布时间',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_organization',
'COLUMN', N'releasetime'
GO


-- ----------------------------
-- Table structure for devt_model_releaselog
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_model_releaselog]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_model_releaselog]
GO

CREATE TABLE [dbo].[devt_model_releaselog] (
  [id] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [code] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [name] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [formversion] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [releasetime] datetime  NULL
)
GO

ALTER TABLE [dbo].[devt_model_releaselog] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'机构代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_releaselog',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'机构名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_releaselog',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'表单版本',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_releaselog',
'COLUMN', N'formversion'
GO

EXEC sp_addextendedproperty
'MS_Description', N'发布时间',
'SCHEMA', N'dbo',
'TABLE', N'devt_model_releaselog',
'COLUMN', N'releasetime'
GO


-- ----------------------------
-- Table structure for devt_zbcfg_info
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_zbcfg_info]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_zbcfg_info]
GO

CREATE TABLE [dbo].[devt_zbcfg_info] (
  [ID] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [zbname] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbcode] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbmeans] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbbz] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbsql] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbunit] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [xsws] int  NULL,
  [delflag] int  NULL,
  [modelid] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [fieldcode] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbclassid] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL,
  [createtime] datetime  NULL,
  [updatetime] datetime  NULL,
  [tablename] varchar(64) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_zbcfg_info] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'指标名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'zbname'
GO

EXEC sp_addextendedproperty
'MS_Description', N'指标代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'zbcode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'指标意义',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'zbmeans'
GO

EXEC sp_addextendedproperty
'MS_Description', N'指标描述',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'zbbz'
GO

EXEC sp_addextendedproperty
'MS_Description', N'指标口径,指标SQL',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'zbsql'
GO

EXEC sp_addextendedproperty
'MS_Description', N'指标单位',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'zbunit'
GO

EXEC sp_addextendedproperty
'MS_Description', N'小数位数',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'xsws'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否删除',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'delflag'
GO

EXEC sp_addextendedproperty
'MS_Description', N'关联模型id',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'modelid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'模型字段code',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'fieldcode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'归属指标分类id',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'zbclassid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'序号',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'xh'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'createtime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'updatetime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'存储表名 devt_zhibiao_val_01,devt_zhibiao_val_01 没200个一张表',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbcfg_info',
'COLUMN', N'tablename'
GO


-- ----------------------------
-- Table structure for devt_zbclass_info
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_zbclass_info]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_zbclass_info]
GO

CREATE TABLE [dbo].[devt_zbclass_info] (
  [ID] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [zbclassname] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbclasscode] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [parentid] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_zbclass_info] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'分类名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbclass_info',
'COLUMN', N'zbclassname'
GO

EXEC sp_addextendedproperty
'MS_Description', N'分类代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbclass_info',
'COLUMN', N'zbclasscode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'上级分类id',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbclass_info',
'COLUMN', N'parentid'
GO


-- ----------------------------
-- Table structure for devt_zbobj_field
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_zbobj_field]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_zbobj_field]
GO

CREATE TABLE [dbo].[devt_zbobj_field] (
  [ID] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [zbobjid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbobjname] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbobjcode] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [modelname] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [modelcode] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [modelfieldname] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [modelfieldcode] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [modelid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_zbobj_field] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_zbobj_info
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_zbobj_info]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_zbobj_info]
GO

CREATE TABLE [dbo].[devt_zbobj_info] (
  [ID] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [zbobjname] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbobjcode] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbobjdatasql] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_zbobj_info] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for devt_zbplan_info
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_zbplan_info]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_zbplan_info]
GO

CREATE TABLE [dbo].[devt_zbplan_info] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [plancode] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [planname] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [typecode] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [typeid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_zbplan_info] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_info',
'COLUMN', N'plancode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_info',
'COLUMN', N'planname'
GO

EXEC sp_addextendedproperty
'MS_Description', N'归属分类',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_info',
'COLUMN', N'typecode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'分类ID',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_info',
'COLUMN', N'typeid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'序号',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_info',
'COLUMN', N'xh'
GO


-- ----------------------------
-- Table structure for devt_zbplan_item
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_zbplan_item]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_zbplan_item]
GO

CREATE TABLE [dbo].[devt_zbplan_item] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [planid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [plancode] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [planzbcode] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [planzbname] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [planzbid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_zbplan_item] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案ID',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_item',
'COLUMN', N'planid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_item',
'COLUMN', N'plancode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案指标代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_item',
'COLUMN', N'planzbcode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案指标名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_item',
'COLUMN', N'planzbname'
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案指标Id',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_item',
'COLUMN', N'planzbid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'序号',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_item',
'COLUMN', N'xh'
GO


-- ----------------------------
-- Table structure for devt_zbplan_para
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_zbplan_para]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_zbplan_para]
GO

CREATE TABLE [dbo].[devt_zbplan_para] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [planid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [plancode] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [paraname] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [bz] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL,
  [paranamezh] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_zbplan_para] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案ID',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_para',
'COLUMN', N'planid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_para',
'COLUMN', N'plancode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_para',
'COLUMN', N'paraname'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_para',
'COLUMN', N'bz'
GO

EXEC sp_addextendedproperty
'MS_Description', N'序号',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_para',
'COLUMN', N'xh'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数中文名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_para',
'COLUMN', N'paranamezh'
GO


-- ----------------------------
-- Table structure for devt_zbplan_paratj
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_zbplan_paratj]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_zbplan_paratj]
GO

CREATE TABLE [dbo].[devt_zbplan_paratj] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [planid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [plancode] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [paraname] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [paraid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL,
  [modelid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [modecode] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [modename] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [tjsql] varchar(4000) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[devt_zbplan_paratj] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案ID',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_paratj',
'COLUMN', N'planid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_paratj',
'COLUMN', N'plancode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_paratj',
'COLUMN', N'paraname'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数ID',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_paratj',
'COLUMN', N'paraid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'序号',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_paratj',
'COLUMN', N'xh'
GO

EXEC sp_addextendedproperty
'MS_Description', N'模型ID',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_paratj',
'COLUMN', N'modelid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'模型代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_paratj',
'COLUMN', N'modecode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'模型名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_paratj',
'COLUMN', N'modename'
GO

EXEC sp_addextendedproperty
'MS_Description', N'条件SQL',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_paratj',
'COLUMN', N'tjsql'
GO


-- ----------------------------
-- Table structure for devt_zbplan_type
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_zbplan_type]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_zbplan_type]
GO

CREATE TABLE [dbo].[devt_zbplan_type] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [typecode] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [typename] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_zbplan_type] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'分类代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_type',
'COLUMN', N'typecode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'分类名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_type',
'COLUMN', N'typename'
GO

EXEC sp_addextendedproperty
'MS_Description', N'分类序号',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_type',
'COLUMN', N'xh'
GO


-- ----------------------------
-- Table structure for devt_zbplan_zbobj
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[devt_zbplan_zbobj]') AND type IN ('U'))
	DROP TABLE [dbo].[devt_zbplan_zbobj]
GO

CREATE TABLE [dbo].[devt_zbplan_zbobj] (
  [id] varchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [planid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [plancode] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbobjid] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbobjcode] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [zbobjname] varchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  NULL
)
GO

ALTER TABLE [dbo].[devt_zbplan_zbobj] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案ID',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_zbobj',
'COLUMN', N'planid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'方案代码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_zbobj',
'COLUMN', N'plancode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'指标对象ID',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_zbobj',
'COLUMN', N'zbobjid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'指标对象编码',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_zbobj',
'COLUMN', N'zbobjcode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'指标对象名称',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_zbobj',
'COLUMN', N'zbobjname'
GO

EXEC sp_addextendedproperty
'MS_Description', N'序号',
'SCHEMA', N'dbo',
'TABLE', N'devt_zbplan_zbobj',
'COLUMN', N'xh'
GO


-- ----------------------------
-- Table structure for TEST_EXCEL_JSON
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[TEST_EXCEL_JSON]') AND type IN ('U'))
	DROP TABLE [dbo].[TEST_EXCEL_JSON]
GO

CREATE TABLE [dbo].[TEST_EXCEL_JSON] (
  [jsondata] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [id] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [_usercode] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [_createtime] datetime  NULL,
  [_updatetime] datetime  NULL,
  [_datatime] datetime  NULL
)
GO

ALTER TABLE [dbo].[TEST_EXCEL_JSON] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for TEST_JSON_TABLE
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[TEST_JSON_TABLE]') AND type IN ('U'))
	DROP TABLE [dbo].[TEST_JSON_TABLE]
GO

CREATE TABLE [dbo].[TEST_JSON_TABLE] (
  [id] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
  [_createtime] datetime  NULL,
  [_updatetime] datetime  NULL,
  [jsondata] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [_usercode] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [_datatime] datetime  NULL
)
GO

ALTER TABLE [dbo].[TEST_JSON_TABLE] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for TEST_ZHIBIAO_TWO
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[TEST_ZHIBIAO_TWO]') AND type IN ('U'))
	DROP TABLE [dbo].[TEST_ZHIBIAO_TWO]
GO

CREATE TABLE [dbo].[TEST_ZHIBIAO_TWO] (
  [jsondata] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [id] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [_usercode] nvarchar(256) COLLATE Chinese_PRC_CI_AS  NULL,
  [_createtime] datetime  NULL,
  [_updatetime] datetime  NULL,
  [_datatime] datetime  NULL
)
GO

ALTER TABLE [dbo].[TEST_ZHIBIAO_TWO] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for TMP_TESTAPITABLE
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[TMP_TESTAPITABLE]') AND type IN ('U'))
	DROP TABLE [dbo].[TMP_TESTAPITABLE]
GO

CREATE TABLE [dbo].[TMP_TESTAPITABLE] (
  [ID] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TESTINPUTTEXT] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [TESTDATETIME] datetime  NULL,
  [TESTDECIMAL] numeric(18,6)  NULL,
  [TESTRICHTEXT] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[TMP_TESTAPITABLE] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for TMP_TESTMAINTABLE
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[TMP_TESTMAINTABLE]') AND type IN ('U'))
	DROP TABLE [dbo].[TMP_TESTMAINTABLE]
GO

CREATE TABLE [dbo].[TMP_TESTMAINTABLE] (
  [ID] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TESTINPUTTEXT] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [TESTDATETIME] datetime  NULL,
  [TESTDECIMAL] numeric(18,6)  NULL,
  [TESTRICHTEXT] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [TESTFILEUPLOAD] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[TMP_TESTMAINTABLE] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for V_TEST_EXCEL_PT
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[V_TEST_EXCEL_PT]') AND type IN ('U'))
	DROP TABLE [dbo].[V_TEST_EXCEL_PT]
GO

CREATE TABLE [dbo].[V_TEST_EXCEL_PT] (
  [ID] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [datatime] datetime  NULL,
  [CODE] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [NAME] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[V_TEST_EXCEL_PT] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for W_DIP
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[W_DIP]') AND type IN ('U'))
	DROP TABLE [dbo].[W_DIP]
GO

CREATE TABLE [dbo].[W_DIP] (
  [dm] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [mc] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [xh] int  IDENTITY(1,1) NOT NULL
)
GO

ALTER TABLE [dbo].[W_DIP] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for W_KS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[W_KS]') AND type IN ('U'))
	DROP TABLE [dbo].[W_KS]
GO

CREATE TABLE [dbo].[W_KS] (
  [ID] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CODE] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [NAME] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [XH] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[W_KS] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for W_YS
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[W_YS]') AND type IN ('U'))
	DROP TABLE [dbo].[W_YS]
GO

CREATE TABLE [dbo].[W_YS] (
  [ID] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CODE] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [NAME] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [XH] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[W_YS] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Auto increment value for devt_api_log
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[devt_api_log]', RESEED, 34)
GO


-- ----------------------------
-- Primary Key structure for table devt_api_log
-- ----------------------------
ALTER TABLE [dbo].[devt_api_log] ADD CONSTRAINT [PK__devt_api__3213E83F16FF24F6] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_api_main
-- ----------------------------
ALTER TABLE [dbo].[devt_api_main] ADD CONSTRAINT [PK__p_functi__3213E83F03317E3D] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_api_sub
-- ----------------------------
ALTER TABLE [dbo].[devt_api_sub] ADD CONSTRAINT [PK__p_functi__3213E83F07020F21] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_api_tjopt
-- ----------------------------
ALTER TABLE [dbo].[devt_api_tjopt] ADD CONSTRAINT [PK__p_functi__3213E83F1273C1CD] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_api_tjoptcheck
-- ----------------------------
ALTER TABLE [dbo].[devt_api_tjoptcheck] ADD CONSTRAINT [PK__p_functi__3213E83F1A14E395] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_api_type
-- ----------------------------
ALTER TABLE [dbo].[devt_api_type] ADD CONSTRAINT [PK__p_functi__3213E83F1DE57479] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_excel
-- ----------------------------
ALTER TABLE [dbo].[devt_excel] ADD CONSTRAINT [PK__sys_crf___3213E83F6C190EBB_copy1_copy1] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_excel_field
-- ----------------------------
ALTER TABLE [dbo].[devt_excel_field] ADD CONSTRAINT [PK__sys_crf___3213E83F6C190EBB_copy1_copy1_copy1] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_excel_log
-- ----------------------------
ALTER TABLE [dbo].[devt_excel_log] ADD CONSTRAINT [PK__sys_crf___3213E83F6C190EBB_copy1_copy1_copy2] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_excel_type
-- ----------------------------
ALTER TABLE [dbo].[devt_excel_type] ADD CONSTRAINT [PK__sys_crf___3213E83F6C190EBB_copy1] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_form_design
-- ----------------------------
ALTER TABLE [dbo].[devt_form_design] ADD CONSTRAINT [PK__sys_crf___3213E83F2B3F6F97] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_form_fieldcheck
-- ----------------------------
ALTER TABLE [dbo].[devt_form_fieldcheck] ADD CONSTRAINT [PK__sys_crf___3213E83F3E52440B] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_form_fieldconfig
-- ----------------------------
ALTER TABLE [dbo].[devt_form_fieldconfig] ADD CONSTRAINT [PK__sys_crf___3213E83F2F10007B] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_form_listtempl_args
-- ----------------------------
ALTER TABLE [dbo].[devt_form_listtempl_args] ADD CONSTRAINT [PK__sys_crf___3213E83F45F365D3] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_form_listtempl_config
-- ----------------------------
ALTER TABLE [dbo].[devt_form_listtempl_config] ADD CONSTRAINT [PK__sys_crf___3213E83F49C3F6B7] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_form_listtempl_otherbtn
-- ----------------------------
ALTER TABLE [dbo].[devt_form_listtempl_otherbtn] ADD CONSTRAINT [PK__sys_crf___3213E83F4D94879B] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_form_listtempl_theader
-- ----------------------------
ALTER TABLE [dbo].[devt_form_listtempl_theader] ADD CONSTRAINT [PK__sys_crf___3213E83F5165187F] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_form_listtemplate
-- ----------------------------
ALTER TABLE [dbo].[devt_form_listtemplate] ADD CONSTRAINT [PK__sys_crf___3213E83F5535A963] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_form_metadata
-- ----------------------------
ALTER TABLE [dbo].[devt_form_metadata] ADD CONSTRAINT [PK__sys_crf___3213E83F59063A47] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_form_type
-- ----------------------------
ALTER TABLE [dbo].[devt_form_type] ADD CONSTRAINT [PK__sys_crf___3213E83F6C190EBB] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_function_list
-- ----------------------------
ALTER TABLE [dbo].[devt_function_list] ADD CONSTRAINT [PK__sys_func__3213E83F9722A3D9] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_model_metadata_field
-- ----------------------------
ALTER TABLE [dbo].[devt_model_metadata_field] ADD CONSTRAINT [PK__sys_crf___3213E83F5CD6CB2B] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_model_metadata_table
-- ----------------------------
ALTER TABLE [dbo].[devt_model_metadata_table] ADD CONSTRAINT [PK__sys_crf___3213E83F60A75C0F] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_model_metadata_type
-- ----------------------------
ALTER TABLE [dbo].[devt_model_metadata_type] ADD CONSTRAINT [PK__sys_crf___3213E83F6477ECF3] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_model_organization
-- ----------------------------
ALTER TABLE [dbo].[devt_model_organization] ADD CONSTRAINT [PK_sys_crf_form_file_copy1] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_model_releaselog
-- ----------------------------
ALTER TABLE [dbo].[devt_model_releaselog] ADD CONSTRAINT [PK_sys_crf_form_file_copy1_copy1] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_zbcfg_info
-- ----------------------------
ALTER TABLE [dbo].[devt_zbcfg_info] ADD CONSTRAINT [PK_DEVT_ZBCFG_INFO] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_zbclass_info
-- ----------------------------
ALTER TABLE [dbo].[devt_zbclass_info] ADD CONSTRAINT [PK_DEVT_ZBCLASS_INFO] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_zbobj_field
-- ----------------------------
ALTER TABLE [dbo].[devt_zbobj_field] ADD CONSTRAINT [PK_DEVT_ZBOBJ_FIELD] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_zbobj_info
-- ----------------------------
ALTER TABLE [dbo].[devt_zbobj_info] ADD CONSTRAINT [PK_DEVT_ZBOBJ_INFO] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_zbplan_info
-- ----------------------------
ALTER TABLE [dbo].[devt_zbplan_info] ADD CONSTRAINT [PK_DEVT_ZBPLAN_INFO] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_zbplan_item
-- ----------------------------
ALTER TABLE [dbo].[devt_zbplan_item] ADD CONSTRAINT [PK_DEVT_ZBPLAN_ITEM] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_zbplan_para
-- ----------------------------
ALTER TABLE [dbo].[devt_zbplan_para] ADD CONSTRAINT [PK_DEVT_ZBPLAN_PARA] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_zbplan_paratj
-- ----------------------------
ALTER TABLE [dbo].[devt_zbplan_paratj] ADD CONSTRAINT [PK_DEVT_ZBPLAN_PARATJ] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_zbplan_type
-- ----------------------------
ALTER TABLE [dbo].[devt_zbplan_type] ADD CONSTRAINT [PK_DEVT_ZBPLAN_TYPE] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table devt_zbplan_zbobj
-- ----------------------------
ALTER TABLE [dbo].[devt_zbplan_zbobj] ADD CONSTRAINT [PK_DEVT_ZBPLAN_ZBOBJ] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table TEST_ZHIBIAO_TWO
-- ----------------------------
ALTER TABLE [dbo].[TEST_ZHIBIAO_TWO] ADD CONSTRAINT [PK_TEST_ZHIBIAO_TWO] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table TMP_TESTAPITABLE
-- ----------------------------
ALTER TABLE [dbo].[TMP_TESTAPITABLE] ADD CONSTRAINT [PK_TMP_TESTMAINTABLE_copy1] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table TMP_TESTMAINTABLE
-- ----------------------------
ALTER TABLE [dbo].[TMP_TESTMAINTABLE] ADD CONSTRAINT [PK_TMP_TESTMAINTABLE] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table V_TEST_EXCEL_PT
-- ----------------------------
ALTER TABLE [dbo].[V_TEST_EXCEL_PT] ADD CONSTRAINT [PK_V_TEST_EXCEL_PT] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for W_DIP
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[W_DIP]', RESEED, 23669)
GO


-- ----------------------------
-- Primary Key structure for table W_DIP
-- ----------------------------
ALTER TABLE [dbo].[W_DIP] ADD CONSTRAINT [PK_W_DIP] PRIMARY KEY CLUSTERED ([dm])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table W_KS
-- ----------------------------
ALTER TABLE [dbo].[W_KS] ADD CONSTRAINT [PK_W_KS] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table W_YS
-- ----------------------------
ALTER TABLE [dbo].[W_YS] ADD CONSTRAINT [PK_W_YS] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

